/****** Object:  Stored Procedure dbo.asi_ProcessEngineTypeByName    Script Date: 7/3/2003 4:58:04 PM ******/
CREATE   PROC [dbo].[asi_ProcessEngineTypeByName]
    @processEngineType nvarchar(100)
    AS
BEGIN
    SET ROWCOUNT 1
    SELECT    ProcessEngineType.ProcessEngineTypeKey,
            ProcessEngineType.Name,
            ProcessEngineType.Assembly,
            ProcessEngineType.QualifiedName,
            ProcessEngineType.HasTemplate,
            ProcessEngineType.HasDesigner

     FROM    ProcessEngineType
            
     WHERE    ProcessEngineType.Name = @processEngineType
    SET ROWCOUNT 0
END

GO